07. Quiz: Logical Functions

Quiz: Logical Functions

In the following quiz, you'll need to combine what you've learned so far in a new way. The special_orders.xlsx spreadsheet can be downloaded at the bottom of the page. Your task is to add a formula in F2 and fill it down the Special Order? column such that the column fulfills the following statement:

If the maximum number of any one fruit exceeds 10 pieces in an order,     
    or the total order exceeds 20 pieces (all fruit),
    then mark it with "Special Order". 
Otherwise, mark it with "No".

When you have provided the correct formula, you should see the following result:

Special Order

QUESTION:

Enter the correct formula for F2. Use only relative addressing for the cell so that it can be easily filled down the column.

SOLUTION:

NOTE: The solutions are expressed in RegEx pattern. Udacity uses these patterns to check the given answer

Next Concept